Notes/Domino 6 and 7 Forum : Two fixes

I ran into this just this week. After trying just about everything under the sun to fix it I came up with this....thanks to some deep analysis with the old R5 tool NotesPeak (man I love that thing). This is completely unsupported and only recommended if you know what you're doing with Notes Administrator and Notes Designer....however it does fix the problem. Maybe someone at Lotus would be kind enough to formalize this into something that happens at upgrade time.

The basic problem is a corrupt Archive Profile...to fix the problem you must delete and recreate the profile....here's how you do it.

1. Create a new memo
2. add a button to the memo with CREATE | HOTSPOT | BUTTON
3. use the following as your LotusScript for the button:

Sub Click(Source As Button)
Set session= New NotesSession
Set ws = New NotesUIWorkspace
Dim db As notesdatabase
Set db = session.currentdatabase
Set profile = db.GetProfileDocument("Archive Profile")
Call profile.remove(True)
Messagebox "Profile has been fixed." ,MB_OK, "Title"
End Sub

4. Now setup the Archive setting with all the defaults.... including the file in which to put the docs (you can always cut and paste them back to your mail file if you screw this up).... this process should create a a_USERNAME.nsf file under \notes\data\archive on your PC....whatever magic those of us in this thread have been missing out on is contained in that nsf file.

5. I had 500MB of mail in my old archive.nsf so I wrote an agent to "moveOut" of the old database as follow....
SIMPLEACTION
copy doc to \notes\data\archive\a_USERNAME.nsf
SIMPLEACTION
delete doc

This is by far the messiest thing I've ever had to do in Notes but I'm guessing that's the prices you pay as a BETA tester (which I believe is where this problem originates).

Here's another way to accomplish the archiver... sweet and simple.

The following will move any documents in the view as per your defined schedule to your archives database. Consult the Lotus Designer Help for details on each @formula. This particular example moves mail docs older than 6 months and calendar docs older than 1 week.

Setup a view with the following selection formula:
SELECT
(Form="Memo" &(PostedDate<=@Adjust(@Today;0;-6;0;0;0;0) ) ) |
(Form="Appointment" & (STARTDATETIME<= @Adjust(@Today;0;0;-1;0;0;0))) |
(Form="Notice" & (STARTDATETIME<=@Adjust(@Today;0;0;-1;0;0;0)))

Next create a scheduled agent to automagically run say weekly through that particular view and copy stuff to a different db (archivedmail.nsf) and then delete each doc in the view.

Simplicity is good.

--
Brett

Notes/Domino 6 and 7 Forum

Document Options

Search this forum

Forum views and search

Member Tools

RSS Feeds